This query shows individual members who registered for an event.
1. Browse to IQA.
2. Select Query from the drop-down list and select New.
3. Select sources:
□ Browse to the Common folder containing business objects.
□ Select CsContact and CsActivityBasic.
4. Define the filtering rules:
□ Select the Filters tab.
□ Mode: Advanced
□ Operator: Where
□ Filter on CsActivityBasic.Activity Type.
■ Comparison: Equal
■ Value: AWARD
■ Click the + icon to add the filter.
□ Select Add Filter.
□ Select And from the drop-down list.
□ Filter on CsContact.Member Type.
■ Comparison: Equal
■ Value: Member
■ Click the + icon to add the filter.
5. Define the columns to display in the output:
□ Select the Display tab.
□ Select the following columns:
■ CSContact.iMIS Id
■ CsContact.Full Name
■ CsContact.City
■ CsActivityBasic.Description
■ CsActivityBasic.ProductCode
□ Using the Order drop-down list, assign:
■ CsContact.City Order 1
■ CsContact.Last Name Order 2
6. Specify the sorting priority:
□ Select the Sorting tab.
□ Sort the results by CsContact.iMIS Id.
□ Click the + icon to add your selection.
7. Save your settings.
8. Run the query.